﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using fuzhu;
using Dapper;
using LKU8.shoukuan.Model;

namespace LKU8.shoukuan
{
    public class MorderService
    {
       

       /// <summary>
        /// 读取U8生产订单
       /// </summary>
        /// <param name="cQianZhui">前缀，代表了年度生产订单，WJA25</param>
       /// <param name="constr"></param>
       /// <returns></returns> 
        public static List<WanJi_Morder_View> GetList( string constr)
        {
            using (SqlConnection conn = new SqlConnection(constr))
            {
                

                //只取末级，and bDepEnd = 1。 查询条件里，不需要这个
                string sql = @"SELECT MoCode as cMoCode FROM mom_order WHERE  1= 1 AND  CreateDate>='2024-12-25' ";
                List<WanJi_Morder_View> lstMO= conn.Query<WanJi_Morder_View>(sql,  null).ToList();
                return lstMO;
            }
        
        }


         

       }
 
}
